Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_STREAMS_TRANSFORMATIONS

`DBA_STREAMS_TRANSFORMATIONS` displays all the transformations available on a system, in order of execution.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`RULE_OWNER` | `VARCHAR2(30)` |  | The owner of the rule
`RULE_NAME` | `VARCHAR2(30)` |  | The name of the rule
`TRANSFORM_TYPE` | `VARCHAR2(26)` |  | The type of the transformation (declarative, subset rule, or user-defined)
`FROM_SCHEMA_NAME` | `VARCHAR2(30)` |  | The schema to be renamed
`TO_SCHEMA_NAME` | `VARCHAR2(30)` |  | The new schema name
`FROM_TABLE_NAME` | `VARCHAR2(30)` |  | The table to be renamed
`TO_TABLE_NAME` | `VARCHAR2(30)` |  | The new table name
`SCHEMA_NAME` | `VARCHAR2(30)` |  | The schema of the column to be modified
`TABLE_NAME` | `VARCHAR2(30)` |  | The table of the column to be modified
`FROM_COLUMN_NAME` | `VARCHAR2(4000)` |  | The column to be renamed
`TO_COLUMN_NAME` | `VARCHAR2(4000)` |  | The new column name
`COLUMN_NAME` | `VARCHAR2(4000)` |  | The column to add or delete
`COLUMN_VALUE` | `ANYDATA` |  | The value of the column to add
`COLUMN_TYPE` | `VARCHAR2(4000)` |  | The type of the new column
`COLUMN_FUNCTION` | `VARCHAR2(30)` |  | The name of the default function
`VALUE_TYPE` | `VARCHAR2(3)` |  | Whether to modify the new or old values, or both, of the LCR
`USER_FUNCTION_NAME` | `VARCHAR2(4000)` |  | The name of the user-defined transformation
`SUBSETTING_OPERATION` | `VARCHAR2(6)` |  | DML operation for row subsetting
`DML_CONDITION` | `VARCHAR2(4000)` |  | Row subsetting condition
`DECLARATIVE_TYPE` | `VARCHAR2(13)` |  | The type of declarative transform
`PRECEDENCE` | `NUMBER` |  | The execution order relative to other declarative transformations on the same `STEP_NUMBER`
`STEP_NUMBER` | `NUMBER` |  | The order in which this transformation should be executed